package cj.web.portal.dao;

import java.util.List;
import net.paoding.rose.jade.annotation.DAO;
import net.paoding.rose.jade.annotation.SQL;
import cj.web.kly.domain.SpecialistLabel;

/**
 * 
 * @author 
 *
 */
@DAO
public interface SpecialistLabelVoDAO{
	
	@SQL("SELECT id,name,pId,value,en FROM SpecialistLabel WHERE deleteFlag=1 AND status=1 AND pId=:1 ORDER BY orderNo ")
    List<SpecialistLabel> queryBypId(int pId);
	
	@SQL("SELECT id,name,pId,value,en FROM SpecialistLabel WHERE deleteFlag=1 AND status=1 AND id=:1 ")
    SpecialistLabel queryById(int id);
}